• Formatting Tools
• Comment / Uncomment Multiple Lines of Code
• What does it do?
• How to access it?
• Auto Indent
• Remove Excess Linebreaks
• Display Line Numbers
• Sort Code

Formatting Tools

Proper code formatting is essential to prevent errors and increase readability. AutoMacro has several VBA formatting tools available:

• Comment / Uncomment multiple lines at once
• Automatically apply proper code indentation
• Remove excess blank lines

In the Misc. Utilities page you'll find two other tools that might also qualify as "formatting" tools:

• Sort code
• Show line numbers in the coding module.

Comment / Uncomment Multiple Lines of Code

What does it do?

The comment / uncomment feature allows you to quickly comment or uncomment multiple lines of code at once. The feature is smart enough to identify when some lines of code are commented and others are not, so if you have a block of partially commented code, you can quickly standardize the commenting.

How to access it?

1. Via the button on the Code Tools toolbar:
   1. 
2. Highlight one or more lines of code and right-click:
   1. 
3. Keyboard Shortcut: CTRL + ALT + C

Auto Indent

What does it do?

Auto Indent adds proper code indentation to the active module.

Proper indentation makes your code easier to read and reduces the chances of errors.

By default the code indentation will indent all code one "tab" to start. This setting can be changed in the Settings Menu:

How to access it?

Via the buttons on the Code Tools toolbar:

and via the right-click menu:

Remove Excess Linebreaks

Often when coding, blank lines can accumulate. The remove Excess Linebreaks tool scans your active code module and deletes blank lines whenever more than two consecutive blank lines are found.

Use this in conjunction with the Auto Indent tool to quickly clean up your code.

How to access it?

Via the buttons on the Code Tools toolbar:

and via the right-click menu:

Display Line Numbers

Read more here

Sort Code

Read more here

Last modified 3 years ago.